


/*==============================================================*/
/* Table: daydeal     */
/*==============================================================*/
create table daydeal (
   id     char(32)   not null,
   code   varchar(10) ,
   name   varchar(100),
   dealdate   varchar(19) ,
   startPrice float,
   HIGH  float,
   LOW float,
   endPrice   float,
   VOL   float,
   riseWidth  float,
   dayNum int,
   VOLRiseWidth    float,
   df     char(1) ,
   ts     varchar(19) ,
   constraint PK_DAYDEAL primary key  (id)
)
go


/*==============================================================*/
/* Table: dealrecord  */
/*==============================================================*/
create table dealrecord (
   id     char(32)   not null,
   happenDate char(10),
   happenTime char(8) ,
   businessName  varchar(20) ,
   stockCode  varchar(10) ,
   stockName  varchar(100),
   dealPrice  float,
   dealNum int,
   dealAmount float,
   stockBalance  float,
   commissionCharge     float,
   stampTax   float,
   transferCharge float,
   otherCharge float,
   happenCharge  float,
   fundsBalance  float,
   entrustCode varchar(10) ,
   entrustPrice  float,
   entrustNum int,
   stockholderCode      varchar(20) ,
   fundsAccount  varchar(20) ,
   moneyKind  varchar(20) ,
   dealGroup  int,
   df     char(1) ,
   ts     varchar(19) ,
   constraint PK_DEALRECORD primary key  (id)
)
go


/*==============================================================*/
/* Table: fiveminutedeal  */
/*==============================================================*/
create table fiveminutedeal (
   id     char(32)   not null,
   code   varchar(10) ,
   name   varchar(100),
   dealdate   varchar(19) ,
   dealtime   char(4) ,
   startPrice float,
   HIGH  float,
   LOW float,
   endPrice   float,
   VOL   float,
   riseWidth  float,
   dayNum int,
   VOLRiseWidth    float,
   df     char(1) ,
   ts     varchar(19) ,
   constraint PK_FIVEMINUTEDEAL primary key  (id)
)
go


/*==============================================================*/
/* Table: stock*/
/*==============================================================*/
create table stock (
   id     char(32)   not null,
   code   varchar(10) ,
   name   varchar(100),
   df     char(1) ,
   ts     varchar(19) ,
   myflag char(1) ,
   constraint PK_STOCK primary key  (id)
)
go


